#!/usr/bin/env node

const mysql = require('mysql2/promise'),
      log   = console.table;
let db = {};
db.insert = async(con, areaName) => {
  const sql = `insert into areas(area_name) values('${areaName}')`;
  const [res] = await con.query(sql);
  log(res);
};
db.update = async(con, id, areaName) => {
  const sql = `update areas set area_name = '${areaName}' where id = ${id}`;
  const [res] = await con.query(sql);
  log(res);
};
db.del = async(con, id) => {
  const sql = `delete from areas where id = ${id}`;
  const [res] = await con.query(sql);
  log(res);
};
db.select = async(con) => {
  const sql = 'select * from areas order by id';
  const [rows] = await con.query(sql);
  log(rows);
};
(async() => {
  const con   = await mysql.createConnection({
        host: '127.0.0.1',
        user: 'root',
        password: 'ddd',
        database: 'demo'
  });
  await db[process.argv[2]](con, process.argv[3], process.argv[4]);
  await con.end();
})();

